EDA
- Since April, the epidemic has gradually become severe and more and more people were tested positive.
- The box plot shows that epidemic outbreaks since April
- Even though the number of canceled flight decreased from May, the total number of flights decreased from April also, which might means that during the epidemic period, only few flights were permitted to fly
- Compared to Jan and Feb, more and more flights were canceled due to security issues after the outbreak of COVID-19.
- Even during the epidemic time, the United States still has the largest traffic volume
- The last plot shows that New York and California are two main traffic center
Column
Covid_19 case and death
Flights Cancelled From Jan to Jun
Column
Distribution of Covid_19 cases
Column
Cancellation Reasons
Traffic to and from Airport in Four Countries
Distribution of traffic to and from each states
Map
- The traffics in the month are mostly remains at 60%-80% of the baseline and this proportion remain same from March to June
- The airports are mostly located in the states where the epidemic is severe such as Carlifonia, New York and Florida.
Column
Traffic Mean Percent of Baseline and Covid-19 cases in the US
Column
Covid-19 cases
Network
- TX, CA ,NY and FL are four main origin and destination states and there are a large number of flights to and from these state. From the map before, these four states also have largest number of COVID-12 cases.
- We can guess that the large passenger flow promoted the spread of the epidemic
Network
Top 1 Destional of Each Origin
Time Series
- number of positive COVID-19 cases increase significantly over time after March
- The percent of baseline of the traffic fluctuates between 35% and 75%, which means that the flight traffic volume reduced a lot compared with the months before epidemic outbreaks
- After the outbreak, the number of flights gradually stabilized
Time Series for the Percent Of Baseline and Covid-19 cases
WordCloud
- From the 2020 tweets, people re most concerned about the epidemic. There are several high frequency words such as ‘Home’, ‘lockdown’ and ‘quarantine’, that could explain the reduce of flight – during the epidemic time, people stay home in order to keep safe. Therefore, the decreasing of flight traffic could because of the decreasing of travel demand and the protection of public safety.
Data Source
- The data sets I used are from Kaggle:
- 1.https://www.kaggle.com/terenceshin/covid19s-impact-on-airport-traffic
- 2.https://www.kaggle.com/akulbahl/covid19-airline-flight-delays-and-cancellations?select=jantojun2020.csv
- 3.https://www.kaggle.com/sudalairajkumar/covid19-in-usa?select=us_counties_covid19_daily.csv
- 4.https://www.kaggle.com/gpreda/covid19-tweets